<?php
include("events/include/db.php");

$in_cat		= $_GET['cat'];
if($in_cat != ''){$cat_from = ", film_cat "; $cat_sql = "  AND films.film_id = film_cat.film_id AND film_cat.cat_id='$in_cat' ";}

//$in_country		= $_GET['country'];
//if($in_country != ''){$country_sql = " AND films.country='$in_country' ";}

$in_venue		= $_GET['venue'];
if($in_venue != ''){$venue_sql = " AND screenings.venue_id='$in_venue' ";}

?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html"/>
    <meta charset="utf-8">

    <title>Sebastopol Documentary Film Festival</title>
    <script src="Scripts/AC_RunActiveContent.js" type="text/javascript">
</script>

    <link type="text/css" href="main.css" rel="stylesheet" />

    <style type="text/css">
	
	body{color: black;}
	
	a{color: black;}

    .style1 {color: #000000}
    .style3 {
    color: black;
    font-weight: bold;
    font-style: italic;
    }
    
    div.rightbody{
    	background-color: white;
    	color: black;
    
    }

    </style>

</head>

<body>
    <table width="100%" height="100%" cellpadding="0px" cellspacing="0px;">
        <tr>
            <?php include "includes/menu_left.php"; ?>

            <td valign="top" class="right">
                <div class="homehead">
                    <img src="images/sdff_header_2011.gif" width="748" height="275" />
                </div>

                <div class="rightbody">
             
             <h1>Venue List</h1>   

              <?php
	$result = mysql_query("SELECT venue_name, venue_id, venue_address FROM venues ORDER BY venue_name", $db);
      	while ($myrow = mysql_fetch_array($result, MYSQL_ASSOC)) { 
      	if($class == 'row2'){$class = 'row1';}else{$class = 'row2';}
      	?>
      	
      	<h4><a href="venue.php?id=<?php echo $myrow["venue_id"];?>"><?php echo $myrow["venue_name"];?></a></h4>
      		<p style="padding-left:15px"><?php echo $myrow["venue_address"];?></p>

            		  
   <?php $nolist = '';  echo "<br>"; } ?>              


         

                </tr>
              </tbody>
            </table>
<br><br><br>
                
                
                </div>
            </td>
        </tr>
    </table>
</body>
</html>
